Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_ENTITY_PARAMETERS

`ALL_OLAP2_ENTITY_PARAMETERS` lists the metadata descriptors not listed in ALL_OLAP2_ENTITY_EXT_PARMS. Additionally, it includes all the descriptors from ALL_OLAP2_ENTITY_DESC_USES.

The metadata descriptors are described in Table 8-1, "OLAP Catalog Metadata Descriptors".

Column | Data Type | NULL | Description
--- | --- | --- | ---
`DESCRIPTOR_ID` | `NUMBER(38)` |  | ID of metadata descriptor.
`DESCRIPTOR_NAME` | `VARCHAR2(240)` |  | Name of the metadata descriptor.
`ENTITY_OWNER` | `VARCHAR2(240)` |  | Schema of the cube or dimension.
`ENTITY_NAME` | `VARCHAR2(240)` |  | Name of the cube or dimension.
`CHILD_ENTITY_NAME` | `VARCHAR2(240)` |  | Name of a child of the cube or dimension. For example, a dimension attribute is a child of a dimension, and a measure is a child of a cube. If the descriptor applies to a cube or dimension, this parameter is NULL.
`SECONDARY_CHILD_ENTITY_NAME` | `VARCHAR2(240)` |  | Name of a child of the child entity. For example, a level attribute is a child of a level, which is a child of a dimension. If the descriptor applies to a cube or dimension, or a child of a cube or dimension, this parameter is NULL.
`PARAMETER_NAME` | `VARCHAR2(30)` |  | User-defined label for the descriptor.
`PARAMETER_VALUE` | `VARCHAR2(80)` |  | Value of the descriptor.